package ie.dcu.spca.model.sql;

public class itemsusersSQL {
    public static String selectItemusersListByItemid = "SELECT * FROM items_users WHERE item_id=%d AND delete_at==0";

    public static String selectItemusersListByUserid = "SELECT * FROM items_users WHERE user_id='%s' AND delete_at==0";

    public static String insertItemsusers = "INSERT INTO items_users VALUES(?,?,?,?,?,?,?);";

    public static String selectById = "SELECT * FROM items_users WHERE id=%d";

    public static String insertByBean = "INSERT INTO items_users VALUES(?,?,?,?,?,?,?);";

    public static String deleteById = "UPDATE items_users SET delete_at=? WHERE id=?";

    public static String deleteByBean = "";

    public static String updateByBean = "UPDATE items_users SET count=?, item_id=?, user_id=?,create_at=?,update_at=?,delete_at=? WHERE id=?";

    public static String selectMaxId = "SELECT MAX(id) as max FROM items_users;";

    public static String existById = "SELECT * FROM items_users WHERE id=%d;";

    public static String isDeletedById = "SELECT * FROM items_users WHERE id=%d AND delete_at==0;";

    public static String selectAllBean = "SELECT * FROM items_users WHERE delete_at==0;";
}
